package com.kandinfo.survey.common.repository;

import java.util.List;

import org.springframework.data.jpa.repository.Query;

import com.kandinfo.base.common.repository.BaseRepository;
import com.kandinfo.survey.common.domain.UserAnswerInfo;
import com.kandinfo.survey.common.domain.UserQuestionnaireRela;

public interface UserAnswerInfoRepository extends BaseRepository<UserAnswerInfo, Long> {

    @Query(value = "select * from user_answer_info where user_id=?1 and answer_date=?2 and status='1'", nativeQuery = true)
    List<UserQuestionnaireRela> findAnswerInfo(Long userId, String answerDate);

}
